SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408511 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408511 [ RunTime:0.007942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56508,94577,921540,1033812,499731,232931,22606,692706,373436,583205,362743,137017,71144,685437,1041740,828063,558801,231354,175752,310695,861702,521945,289140,353905,416770,493178,816968,424000,85435,979939,789169,902359,938355,700996,451022,519002,202627,962875,293397,740333,776161,934876,938604,983201,186548,177,317859,691489,910497,936654,289223,65002,97637,631870,578532,752316,85510,817812,361102,434298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001520s ]