SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470782 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470782 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028810,987640,104288,962269,377342,180970,125298,834113,312079,205296,96611,245864,168731,569322,75358,1025842,417127,513940,816186,138861,1027758,880332,706181,389340,235326,155009,343910,832810,328060,189451,916788,651256,945308,193045,223055,365408,772058,705200,223527,203104,123416,379972,56120,347388,897318,107472,150770,366036,142473,504063,824246,966621,983084,262982,978564,810155,162485,354535,763427,1009885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470782 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470782 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000771s ]