SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108143 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108143 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (686962,290693,1009580,875508,692062,1043180,1023933,163085,260128,165019,959017,733665,65939,701106,163015,669695,883263,182058,406922,246026,386866,814172,665060,1042309,294359,38200,1039936,198770,376124,477898,946815,757230,853382,1025170,575647,794958,119290,496419,746399,725828,217755,554193,774187,955120,707725,20704,449928,1036258,408297,556623,367319,232804,161805,585787,85607,137601,1040641,932804,141138,328077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]