SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438212 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438212 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398937,173934,68838,825559,124433,35478,610960,268994,867451,771124,140311,389875,754924,510574,933196,136503,984870,737837,222852,728533,930739,917674,49957,964190,360408,87104,165831,603645,467267,198181,445570,606015,394651,501702,970080,105376,488318,530386,291708,960029,236330,217271,80655,688725,979223,703011,1035858,46652,626568,925498,135215,151744,1043455,409288,900220,845654,452234,807212,969016,853852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000804s ]