SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 94160 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 94160 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950763,96711,163348,961995,589562,159348,710965,209732,312922,394205,548382,890622,679249,186148,351610,891710,973801,678330,343978,556541,994167,255019,340189,340690,926263,161973,681018,299970,81140,856216,1016998,750645,621572,297667,809774,26051,1021869,138990,319511,793526,1004131,80468,969624,340144,681671,92443,247780,839322,215406,1010505,537320,170424,66447,17572,686341,455243,265675,828925,96549,800998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 94160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 94160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]