SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48115 LIMIT 1 [ RunTime:0.000649s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48115 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720563,342849,240668,1016270,795316,71260,1024599,245917,460571,245671,389405,392694,444609,498352,512506,278410,483117,869624,666276,64475,180340,834532,40041,237975,891568,250880,364446,566866,961552,13740,877201,138665,205608,282044,820341,783978,849527,99998,385716,107640,656089,90848,273660,137188,511020,614560,110677,787088,689286,748516,279935,198950,640120,689205,410173,759743,93468,311242,187151,347455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000822s ]