SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002063s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344809 LIMIT 1 [ RunTime:0.001812s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344809 [ RunTime:0.005728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753852,287480,930902,407790,209988,101993,653184,797945,487284,308540,878077,544007,732514,299091,1031461,204309,305722,411942,95916,662280,661482,714914,217202,86638,39463,22703,866329,308449,170047,680463,535374,712816,426293,745768,684406,844649,722815,405301,420859,100611,574105,366366,432807,129872,695698,711013,338347,911318,376457,525628,413089,867625,117949,199473,501307,497142,428114,901246,218000,778936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001538s ]