SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331811 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331811 [ RunTime:0.002814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445668,105644,634439,878775,140537,1039559,153603,131725,297274,959868,166064,359290,375435,627205,223358,984037,679186,746830,595740,346083,105899,954586,859182,311519,260881,958699,73496,160493,748850,991872,597733,150260,900746,393192,431900,179738,39091,860897,1037170,746076,844527,754700,975493,318690,163636,390396,1023254,842042,10331,323703,1020660,599166,742306,172411,219469,420201,69420,939058,871093,641499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]