SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806993 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806993 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680516,32497,331048,74102,158023,549067,844025,22316,607207,102671,74487,211568,555639,1038116,89774,250051,751322,268862,114524,576172,836736,895857,559469,998970,55189,141730,222076,989593,516986,173778,221975,572093,542129,529230,110897,381412,723459,104503,608057,908858,427897,465026,776152,108921,753985,312784,298320,141912,795750,329862,1030612,567858,38664,651708,360827,566125,897902,895476,157550,791847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000387s ]