SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354235 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354235 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022119,371100,851496,443954,907076,62415,67266,708683,993328,260498,183605,195768,864481,884935,368890,971991,539364,733011,372596,426355,641071,431659,155326,146999,358638,422215,167087,877880,772871,967464,91962,348972,32309,892053,100669,452161,237909,759144,3346,77868,180741,330007,992126,794986,648286,911564,740831,718418,20985,696557,467420,378660,513882,1004787,7505,966252,420982,910054,112157,231157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354235 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354235 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]