SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510041 LIMIT 1 [ RunTime:0.003092s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510041 [ RunTime:0.007463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114088,413308,925954,969070,230580,867461,828397,710003,929117,204098,9496,321698,58080,528262,713576,60737,670810,882722,993577,961579,876051,546137,163868,153697,104643,807651,666904,86091,672233,501574,214556,640837,614249,45824,689630,222011,581014,23886,594994,905858,259607,334713,877180,821901,330403,287532,529079,924860,761730,80625,590863,65209,544084,1019606,331382,954198,472566,151896,367469,188022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002480s ]