SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016328 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016328 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313668,150250,408181,590958,979587,567861,491477,921354,916961,163349,1011709,66283,751730,170558,662500,606348,134651,409317,315545,137877,73304,808308,333625,875286,430205,23570,650062,888651,532378,667260,811608,641382,909724,249028,88330,76237,836920,969307,571978,240950,39730,684003,896161,812997,636239,403865,937712,127398,984503,349479,900408,361561,61456,291745,656824,217584,177814,313282,250649,625522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]