SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462013 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462013 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046340,318005,721762,222042,812194,1021948,1013441,48061,504991,387419,1003420,991378,300486,62865,739985,542308,671064,812261,631094,1037834,545362,109445,723086,1007969,31682,785452,979281,792772,504386,839105,271723,390190,736998,512609,537018,799089,969389,408891,917736,783620,890681,870253,947353,958326,695606,90751,487327,272554,540849,1039216,479210,734013,916405,348381,1032734,670563,828342,306520,676154,485099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]