SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401640 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401640 [ RunTime:0.002555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890648,898612,553217,697289,505476,591179,19047,483975,838379,640408,792375,565663,911876,496370,928072,406616,908889,995194,644285,6439,524768,524353,866328,902719,677406,886835,163169,393635,553071,728004,47846,255871,913379,817083,867411,876475,529712,850807,328897,717518,976841,139211,56651,424284,705942,417185,133325,164694,954590,56200,404230,939842,816200,789550,889576,244052,707880,204029,629278,896527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]