SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528018 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528018 [ RunTime:0.002656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817101,1009451,186106,593997,703788,899943,480939,928322,609964,35093,250567,582562,768991,471090,511881,368448,831267,221439,78748,253595,138428,927323,1021144,40336,601981,154848,513613,855579,115335,681539,1045050,20607,379694,813327,99831,718979,463859,1012757,1019384,199097,983351,1028046,632292,147777,374236,839959,850240,556855,96188,1031077,170093,139971,761461,297243,134573,401959,115606,461461,217785,621260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]