SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474407 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474407 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542318,908998,303273,720030,591887,566965,563358,350266,932213,191394,770914,956203,313823,90465,498955,913356,392113,1031951,725301,247253,449514,847718,155565,390524,671682,678657,524349,753293,189067,372075,1017127,519967,761387,942976,1027393,943237,705234,9067,557723,40190,593499,802394,403963,828873,149019,392927,1033795,531906,102153,764831,164250,98899,143079,668594,958350,683891,705729,991647,959865,644140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002131s ]