java - How to optimize the interface to return large amounts of data?

Requirement description: The peripheral platform calls the interface to query the user's song list recommendation information based on the mobile phone number. Each user will have about a thousand pieces of recommendation information. Each piece of recommendation information includes the fields of s...

世界只因有你 2017-05-17 10:00:33 0  4  936

Regarding php business logic and mysql optimization issues

There is a usr table that stores uid, username business table 1, the stored information includes field uid, username business table 2, the stored information is only uid, (multiple data in business table 2 corresponds to one piece of data in business table 1) Existing: Query Traverse business table ...

赵。。。。赵得住 2018-07-11 11:43:28 0  3  1209

Please ask for an eloquent related query in laravel

Table structure {code...} Now we need to query the permission_id list in the permission table based on the user_id in the Auth::user()->id where role table and then based on the role_id. . . How to write this using eloquent?

ringa_lee 2017-05-16 16:55:49 0  2  403

php - Taobao order splitting table design

Our mall currently uses two tables, the ORDER table and the ORDER_DETAIL table. The ORDER table only saves user information, addresses, total prices, etc. The specific product information is stored in the DETAIL store, but now it is divided into two orders to be completed by different merchants. , h...

过去多啦不再A梦 2017-05-25 15:08:21 0  2  2224

mysql - How to implement multi-table association query?

{Code...} The above are three tables in the database, related through UserID. Table A is a user login information table with LogID as the primary key; Table B stores user active status, and Table C stores user geographical location information. Now I want to get the cumulative sum of the number of o...

巴扎黑 2017-07-04 13:44:12 0  1  1123

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  488

MySQL: How to use CASE with ORDER BY clause

I have a stored procedure that has to return a table after filtering rows based on input. Two of the inputs are sort_column and sort_dir. The query must ORDERBY sort_column in the sort_dir direction (ASC or DESC). I tried the following query without success. The query below has been simplified to in...

P粉463291248 2023-11-01 17:44:15 0  1  659

MySql and SQL settings before update trigger Updates of different tables/columns cannot update tables in stored functions/triggers

I have a join table with 2 tables (A and C) with n:m relationship. The connection table (B) also holds some information. A-----B------C In table A, I have a when_modified column that I always want to keep up to date if anything changes. This should include changes on Table B. So I have a pre-update ...

P粉677684876 2023-09-14 21:54:36 0  1  586

About querying the picture of another table corresponding to the product table id based on the product table id

Teacher, based on the product table id, query the picture corresponding to the product table id in another table. Is there any other way to achieve this? Give me some ideas. I think all the methods are written in the public folder. If you re-assign another field in the volist loop, it doesn't seem t...

靖哥哥 2019-05-29 11:47:49 0  2  1321

java - Spring integrates mongodb and reports a duplicate primary key error based on the primary key _id query

1.mongoTemplate.findById(id, clazz, collectionName) queries based on the primary key _id and reports a nested exception is java.lang.NoClassDefFoundError: com/mongodb/MongoException$DuplicateKey2. The problem is very strange. Some _ids can be found without asking...

巴扎黑 2017-05-24 11:35:45 0  1  1198

The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values

EDIT: The formula should be the "value" column - the "value" column with the lowest user_id based on the category. So row 2 will be 0.04 because the "value" column of the lowest "user_id" for category "A" is 0.01. Feel sorry. I want to retrieve every...

P粉178894235 2024-04-06 21:23:40 0  2  867

Get the start date and end date of the creation time

Need help, I need to get start_date and end_date from creation_time based on is_active status. I tried several queries but didn't get the correct results. Table example iduser_id name leader_nameis_active creation time 629DFAS02021-10-1062029DFRB02022-02-09108829DFAS12022-06-30 The result should loo...

P粉265724930 2024-02-21 18:25:26 0  1  442

Experiment with sorting after query limit

So this is my first question here, please forgive me if something is wrong. I'm trying to make a sort query based on constraints. So there is a Customers table with 90 records. I want to first perform a query limited to 3 records, and then sort the results of this query by a column called ContactNam...

P粉237125700 2023-09-05 14:46:42 0  1  724

How does symfony know which configuration file should be used currently?

I took over a new project based on symfony and found that there are many configuration files under /app/config, config_stage.yml, config_production.yml, etc. The system has been using the information in config_stage.yml to connect to the database. Now I need to switch to config_production....

阿神 2017-05-16 16:44:36 0  1  400

How does php+mysql return data in pages according to the matching rate?

For example, in this function, users can set their own tags, and then other users can choose the user tags they want to match, and return user information in pages from high to low according to the matching rate. In this way, how to design the table structure and how to construct the query statement...

Nine 2022-05-16 11:17:15 0  0  1120

javascript - JS query whether the first 8 or first 6 digits of a set of 10 digits match

I want to implement a function that when the user clicks the query button after entering a 10-digit number, it will match the pre-input value in the json data and feed back different query results based on different information. However, the pre-input value of json is only 8 or 6 digits (correspondi...

phpcn_u1582 2017-05-19 10:45:33 0  3  594

Instructions for collecting books during the charity live broadcast on the evening of November 2, 2018!

Students who participated in our charity live broadcast last night to deliver books, please be sure to complete your personal information first (note: the mailing address will be based on the information you filled in!), we will send out all the books with SF Express next Friday! Note: The list of s...

z老师 2018-11-03 14:12:07 0  41  18385

laravel - Design issues about enterprise internal system architecture design

The company currently has about 500 employees and is considering implementing some management systems. Already online is HRMS (which stores basic employee information and also involves some basic personnel processes), which is developed based on Laravel 5.2. I didn’t expect so much when it was origi...

曾经蜡笔没有小新 2017-05-16 16:49:45 0  1  762

Safe way to update mysql table entries using dictionary in python (prevent SQL injection)

I'm writing a helper function for my web application that updates the database based on some information obtained from an external API (not user input). I have the following code, but it is marked as "unsafe" by the Banditpython package. Ideally I could write a function in a way that hardc...

P粉627427202 2023-09-08 20:06:07 0  1  698

The "v-model" directive requires valid attribute values ​​as LHS

I have a Vue application and I have a table where each row has its own id. I then need to show/hide some elements based on a condition in the v-model directive which compares the row ID to the value in the model. The code looks like <b-loadingv-model="actionLoading===table.row.id">&l...

P粉011912640 2024-03-27 15:53:34 0  1  456