SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106894 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106894 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572404,195323,104521,668302,854297,917510,352467,88669,381574,296502,847414,892144,520724,151600,347408,1039412,508822,974948,641429,148161,1011438,181290,472027,622569,92300,910276,321948,991817,529812,6391,611606,561441,223779,575737,991069,775627,550224,102040,565140,99553,384033,817310,392439,993621,999485,720896,54558,587204,128560,291734,300742,916939,1006786,755970,87473,838294,849115,323143,690510,460556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]