SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985315 LIMIT 1 [ RunTime:0.000909s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985315 [ RunTime:0.002994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408041,36577,1001829,1023821,310959,37478,928976,23608,423879,841123,741125,217810,564732,967545,648250,108179,794991,579530,660628,622246,920952,249359,844795,377313,1019683,499794,445586,403169,1008935,616650,256941,405644,711054,821109,688374,366011,502537,328030,824563,704233,936799,358550,539835,615748,584037,48844,36660,20495,853852,804406,191200,714813,623111,821420,723401,450429,214343,654125,911199,1036834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]