SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328344 LIMIT 1 [ RunTime:0.003661s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328344 [ RunTime:0.005845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328841,366365,431513,92629,143405,752908,176591,867564,747027,490278,184934,104874,972634,865870,810219,219264,118962,525009,637252,899798,684833,420250,647953,520838,455300,503578,146215,667718,651207,82582,671637,695833,205853,766787,197724,932305,402241,963265,819922,615079,484465,835917,909720,877320,479472,316027,350378,233377,642455,549794,284846,907495,118666,59640,527524,414884,265233,122924,115608,963086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]