SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45360 LIMIT 1 [ RunTime:0.000597s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45360 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220016,461050,1034764,652412,230918,413672,778848,841186,132802,278692,242680,739780,897398,844838,79081,882812,289810,543029,222878,163979,914388,135959,20091,533434,659065,675385,884282,768274,77945,724295,805691,379884,481111,283610,350555,90227,92929,106733,415661,763010,447179,762237,734257,244915,475844,487989,820576,36450,1006975,569973,433702,297498,772707,971537,661854,489204,590210,377014,190220,837210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45360 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45360 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000807s ]