SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59190 LIMIT 1 [ RunTime:0.000676s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59190 [ RunTime:0.002292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2614,240741,274866,140330,778255,2945,1038579,730021,842121,78605,826057,54340,895809,952205,493159,698107,538424,296197,100808,534308,685754,164677,503064,161898,962224,822204,98983,384587,31450,893724,987051,755598,8845,877138,951257,414568,21637,578179,26000,632683,158310,433047,221138,68194,740508,845981,522906,535435,614018,648600,802045,278394,241169,949477,940883,276363,66332,339980,137209,476714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]