php - Yii relational table with optimized query to avoid N+1 query questions

For example: the details page of a post hasMany is associated with the comment table. The comment table hasOne is associated with the user table. The user table hasOne is associated with the user data table. Then for the comment list, the user table can be queried through the with('author') associat...

阿神 2017-06-10 09:47:45 0  2  1202

Looking for a way to use models to perform multi-table related queries under TP5?

Dear masters, when I use tp5 to query multiple tables, I use the view query method, similar to Db::view('table_a')->view('table_b')->view('table_c') ->view('table_d')->view('table_e')->select(), please

阳光 2018-10-10 08:44:29 0  4  1852

Please tell me how to operate the related table query?

The teacher taught single table query or simple query in class, but related query was not mentioned. How should I do it?

东东 2021-04-28 09:01:36 0  2  983

java - Mybatis related query

In actual development, Mybatis one-to-many and many-to-many related queries use reultMap reference, javaType reference or select reference. Which one has better performance? Will using select lazy loading improve query speed and performance?

ringa_lee 2017-05-27 17:41:50 0  1  671

Ask a question about related query in laravel

It is a many-to-many relationship. {Code...} Now I want to query the name field of the roles to which all users belong. How to write this related query using Eloquent ORM? solved. . {code...}

淡淡烟草味 2017-05-16 16:55:10 0  1  349

Multi-table joint query problem

select pid,count(*) from table1 group by pid; Find out the total number of occurrences of each pid. The problem arises. The name corresponding to the pid is placed in another table. Now it is necessary to directly display each pid through a joint query. The total number of times name appears

nearest 2017-10-24 21:26:41 0  1  1290

How to use laravel multi-table query?

USER table, field id, nameACCOUNT table, field, id, name, account ORDER table, field, id, uid, aid, content There are 3 tables. How to use related query in laravel to query the order in the order table through the user id in the user table Detailed information, and then query acc through the aid in ...

phpcn_u1582 2017-05-16 16:47:53 0  1  512

thinkphp3 joint table query

Take out several pieces of data from a table that satisfy the status value = 2, and then use the IDs of the pieces of data to check other tables. How should I do it with thinkphp? I’m not very good at joining tables to query select * from re_deposit where deposit_status = 2 select * from re_client I...

迷茫 2017-06-07 09:23:28 0  1  1034

TP5.1 Implement search function in multi-table related query

Problems with the multi-table associated search function: The code is as follows: // Implement the search function $productName = Request::param('productName'); $storeName = Request::param('storeName'); if ( !empty($productName) &a

Jackie 2020-06-16 22:43:38 0  4  1868

Is there a more detailed explanation of related query? What I want to implement is as follows

service_category classification table, service_infor information table. These two tables, the information list needs to be related to the classification name of the classification table through the classification field sid (classification table id).

天若有情 2019-08-22 10:11:27 0  2  1043

TP5 multi-table query return type?

Can tp5 multi-table query return objects? How to write it?

…… 2017-08-06 17:54:09 0  3  1219

mysql optimization - How to design the index when there are order by and sum in mysql multi-table joint query?

If there is currently a SQL statement that requires a joint query between two tables and uses group by and order by, how to design an index better? The example is as follows: {Code...} In this example, there are both tables a and b. The joint query, the sum() function for the b table fields, and the...

为情所困 2017-06-15 09:21:07 0  1  1416

Golang GORM implements data retrieval and join table query of many-to-many relationships

I'm using golang1.19 and ORM as GORM. I need to retrieve products using category ID. The product table and category table are bound to a many-to-many relationship. So the third table is product_categories. What I need to do is when a get request comes with a category id, I need to retrieve the produ...

P粉908138620 2024-01-04 13:57:53 0  1  442

MySQL query to convert rows of multiple tables into columns

I need to ask you about MySQL select query from 3 tables. I have 3 similar tables: table_1menu_id|menu_name1|menu12|menu2table_2item_id|menu_id|item_name1|1|item12|1|item23|2|item34|2|item4table_3price_id|item_id|currency_code|price1|1| EUR|3.652|1|USD|3

P粉882357979 2023-08-13 16:02:22 0  1  529

java - Mybatis database multi-table related paging problem

For example: there are two entity classes User and Address {code...} Database: {code...} Mybatis mapping configuration: {code...} The relationship between users and addresses is: one user has multiple addresses, An address can only belong to one user. One-to-many Assume that the current demand is to...

黄舟 2017-06-10 09:49:39 0  6  1492

php - Two tables in Laravel are related through multiple fields. How to write the model relationship?

For example, table A has x_id, y_id, and table B also has x_id, y_id. The two fields in table A are 1 to multiple B tables. {Code...} There are belongsTo and belongsToMany in laravel. Finding relevant documents may not be able to meet my needs. The key is that there is an And relationship here.

漂亮男人 2017-05-27 17:43:51 0  1  741

How to display multiple tables from one ID column using MySQL query

I'm trying to find this query where I want to show which hosts use which template from my Zabbix table. The only problem is that the hosts and templates are registered in the same table. They are mixed in the table, for example ID11813 is the host and 11815 is the template. Now I found a table that ...

P粉207483087 2024-03-26 10:18:45 0  2  350

php - Is there any performance problem if the sql statement is written like this? ? How to improve? ?

Multi-table joint query + subquery + conditional query + sorting {code...} Related data tables: csp_car_brand, vehicle brand table: csp_car_type, vehicle type table: csp_car_source, vehicle source table: csp_car_model, vehicle model table (specific to the brand model): ...

高洛峰 2017-05-24 11:30:34 0  1  573

How to optimize tp6 query

When the tp6 model is associated with multiple data tables for query, the query will be very slow. How can I optimize it? Is there any optimization method? Help! ! ! ! !

以后会怎样 2023-11-17 08:50:36 0  0  642

How to manage MySQL slow queries when comparing two tables in a master-detail relationship: A step-by-step guide

Please help me.. I have a query as follows: This is a table: delivery_orderdelivery_order_itembstbst_item I want to show items that exist in delivery_order/item table but not in bst/item table, comparing based on KODE_BARANG and JUMLAH. I have the query below, but it's still very slow if there's alr...

P粉724256860 2023-09-13 16:56:06 0  1  463