SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801467 LIMIT 1 [ RunTime:0.002179s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801467 [ RunTime:0.001450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (795181,413924,352523,587460,419659,693359,779754,708722,100809,525410,486577,193368,543031,299688,906211,2514,552802,815735,762743,21742,418635,591315,3211,597845,410173,646135,133174,420851,673895,10682,209898,209801,716643,76525,333722,829639,893658,322848,799950,340288,735833,290617,42340,213390,108444,895017,364706,948752,822586,307292,477301,577562,708287,77640,322221,239511,224770,690626,649466,417506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801467 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801467 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001630s ]