SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356223 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356223 [ RunTime:0.005500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209511,1016846,120074,841103,1022844,743798,514546,58011,297610,843213,854175,454443,718507,562991,1011158,208997,966314,695202,973103,545952,443943,278381,93780,22660,465600,994806,984283,419280,1046211,758754,70887,382397,375117,684060,684342,263587,386356,187915,918009,294926,895266,81001,958470,434718,510226,1005970,127802,233830,695343,328367,789545,399523,160390,12190,11806,847568,427570,231131,228265,697837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]