SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424527 LIMIT 1 [ RunTime:0.000913s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424527 [ RunTime:0.005106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031989,455599,1035711,136977,103295,478302,252530,607682,846893,568251,791914,1032458,613436,592879,104528,466285,1040580,775040,864575,471432,859640,989883,916282,259564,1040016,102455,321955,191461,165111,437626,836080,1020844,726026,657435,2823,155703,637371,414778,532238,758291,952913,86908,294730,724840,422955,18241,93295,473751,213912,314952,198164,613929,684074,177360,230141,673398,219837,206301,220513,118447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]