SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343623 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343623 [ RunTime:0.002644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353059,183825,942501,245463,490603,324763,165703,227055,211944,141144,392898,321379,86164,95745,797858,75893,205110,949706,437340,79839,717029,234823,1004169,572669,404020,376012,198133,160964,826850,120577,732645,19013,473594,880720,29103,965172,357242,449708,91163,129580,147539,115371,134097,965214,192254,455523,310759,64824,481728,562275,1002032,184902,210929,998650,656347,170382,878630,146950,547163,416856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]