SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429621 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429621 [ RunTime:0.003760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126594,238358,424375,814784,109446,492205,733915,390249,356509,645551,146753,30220,7587,150792,109398,13493,987070,959597,1045388,671400,147519,142327,934675,657041,373131,571075,542248,776109,354123,260416,300025,500645,873061,390006,819457,208235,315707,790062,541393,1019215,768146,863597,1028149,269832,300938,186994,95379,189669,958737,811276,245733,655996,1027359,792351,298104,803303,948750,985189,763199,753218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001138s ]