SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040517 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040517 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83971,129835,302134,426150,972074,663908,982757,211897,1034622,915199,18545,866437,553149,22946,484786,490740,163828,955826,1008350,831515,885505,631450,788556,114866,241412,368934,911154,705581,26642,105206,962150,819015,888364,305614,651855,998443,493313,540832,880612,515968,620733,461943,566087,454138,331911,466822,168859,967667,471341,546714,964680,107482,120938,48579,704790,518328,335213,945379,566157,695179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]