SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011663 LIMIT 1 [ RunTime:0.000971s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011663 [ RunTime:0.006493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916989,955055,210231,940447,343618,342504,255633,78714,649618,416494,516703,1002477,1039338,419566,795036,777013,675493,553439,951185,581194,414239,475207,469374,437613,547182,918355,967916,266576,323823,237659,530369,661643,436209,214157,276135,80533,984097,772376,415911,258269,662844,667647,154722,1004223,362603,16108,965759,241545,1044875,665030,1047885,851384,672512,645988,979368,284394,740315,510379,1020191,154056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001695s ]