SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000511 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000511 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471518,1011331,965457,636580,750968,10343,460225,745616,151511,659187,256552,532273,155433,725043,948275,357129,194454,106433,84607,214838,820826,64129,611327,945483,854290,185464,770475,591003,340063,199671,294900,819216,185348,3713,645531,632646,985551,113577,90896,792682,666382,234925,810309,580029,414554,1004526,273826,500531,428089,759013,35874,324641,266541,777391,33521,989412,855795,538384,401560,229230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]