SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518212 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518212 [ RunTime:0.004249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590075,1028103,8805,235125,321861,763880,492049,120148,586647,103395,51056,531424,905792,616898,717266,958192,16232,764303,831224,179611,181842,729852,625676,738178,825485,705986,533537,644628,121261,348690,220856,381145,719974,254465,993092,214141,530976,179635,925271,686299,512265,179145,253554,257007,722009,173668,402482,418698,371699,387869,856336,833424,662915,835161,8084,378890,763705,757178,855909,752422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]