SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488060 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488060 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644617,581954,107571,72756,742449,425944,172066,60711,666409,188471,480686,1017600,516735,898189,767834,535948,879186,656215,13602,850896,381481,115028,951486,515075,102092,977194,424051,974463,1034256,107314,14512,8954,982787,777380,323450,173872,508006,838868,308886,889899,292415,649765,860961,307076,221258,860500,54711,474892,230447,570682,190823,498049,265145,1016128,77862,141503,904322,536851,150542,296667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]