SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146086 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146086 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469012,976836,880220,1036481,855392,622826,606333,277143,309146,313987,1045439,402623,30731,400371,547196,335305,468771,214869,424136,28603,320649,611464,67718,152810,861450,46103,808372,283863,805643,1029217,1037434,845818,483369,612532,539451,288042,95105,290152,218249,811900,610854,580770,961910,892070,401858,447077,1002618,774506,1008335,902605,180611,803432,682084,46682,819480,137403,411320,904970,802322,417385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]