SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112522 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112522 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382098,406533,496323,221784,247042,1016909,453822,490942,157124,791461,798211,360734,106068,898428,154019,132747,875307,203299,632581,109801,705556,851048,958576,142245,682603,590863,961470,40754,819042,196956,378247,972376,25382,892768,653209,40317,29040,269305,207633,535060,148370,911153,232154,794019,737271,1036898,544731,664061,814163,836910,538816,944040,404556,812840,841705,713804,981126,771070,941127,955090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]