SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418589 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418589 [ RunTime:0.003506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263984,1001179,766843,187594,534994,111669,1009131,427175,927156,684672,293475,723681,342474,109774,836495,790230,863354,295846,52659,950206,739777,8155,476929,845418,827509,11025,927743,426427,265205,909007,1018877,32929,405127,260829,1037507,946613,1012686,589427,347912,463014,1021315,54519,853580,779780,492994,729831,461442,570,815269,485348,1023123,31011,1003893,713284,230375,620171,898781,527115,691532,878095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]