SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488303 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488303 [ RunTime:0.002112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609712,702695,982503,704995,262958,169309,190311,1025549,990164,506484,112053,370677,38112,942996,627990,874627,184579,689785,152688,486795,980179,858085,419360,9878,110497,571520,1039649,348870,877454,947945,269954,823180,427012,227838,419562,503999,40655,26201,347625,987557,92267,914577,771419,746938,500143,938374,82076,829727,426704,476543,308311,309364,303612,791822,462267,672932,636823,883953,68300,679900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]