SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517854 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517854 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601099,1032288,1019076,852319,224261,400225,46895,265710,1035940,217398,296875,358868,920597,999002,731511,845704,642010,590532,1029810,374253,177129,547834,215654,54308,526221,456718,758413,433234,586694,660598,663049,579181,157677,184521,635368,274905,325275,165818,875028,742351,407521,12231,950361,557348,181881,204273,868331,363364,10629,320250,743048,378689,225471,312357,80139,946414,415964,396549,542581,465140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]