SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453220 LIMIT 1 [ RunTime:0.000906s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453220 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64315,955281,428578,748463,261086,531859,242478,109951,409939,325014,203850,484806,1005292,706198,600505,756300,396217,131900,1043131,881295,1043715,883209,662136,146070,395088,814725,269748,229714,183672,917857,358887,936238,665438,492164,836980,594942,1015497,688533,334250,299991,71903,822990,701625,228353,1042009,674303,332916,995250,891467,890295,1020840,692977,52634,568094,365157,967118,299685,674187,922618,313602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000880s ]