SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861968 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861968 [ RunTime:0.002084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015358,533458,630711,499308,717587,249000,260286,700037,621597,772058,973853,675132,126935,145866,375039,21694,499280,1042398,1048065,184948,1013340,913362,590827,300618,588603,340250,949417,454870,125633,820144,96749,992830,130556,539151,209815,445442,812465,80688,166609,443866,275709,799142,176290,597591,871823,1000880,713483,966726,226816,358557,583170,595424,134560,87794,1033764,587076,640058,884054,517773,447776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]