SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017409 LIMIT 1 [ RunTime:0.002181s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017409 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023429,51865,444762,59738,783919,797105,911094,206440,620931,399804,248341,551327,209466,589834,898198,119749,122718,808911,44237,224285,186858,205607,596255,691560,803436,118620,149295,942924,294773,498498,527812,340697,716548,697413,819331,47362,345532,565934,1005664,875469,168954,902374,987047,525239,175202,174100,436215,219643,550044,714595,669656,130448,386100,918157,52508,540460,255480,923896,723628,306263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]