SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38148 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38148 [ RunTime:0.003390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971045,96983,471337,260953,819309,335396,164926,451922,155193,914493,894528,863457,127473,482782,104886,656155,699310,602873,52105,812796,557143,424095,1007257,98800,9561,438854,662311,264042,447743,1000359,390374,29544,460354,559324,407723,322115,853465,861395,409270,250022,121923,295182,357449,423899,730222,642205,541660,707948,480631,354281,531811,376558,441115,350180,178337,65489,595653,51212,470119,835542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001097s ]