SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453868 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453868 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490019,1043919,880708,828307,198452,975961,109099,705460,148256,489523,49224,199707,530814,258282,952389,115629,848091,421804,143208,72983,807917,379548,147601,203337,822119,827878,449431,468333,14000,183627,979703,972893,142506,1016963,667401,475210,509140,990591,1019270,184225,56116,65269,662094,274981,701869,660223,642990,791692,724719,580391,292099,20564,501889,20531,250394,82093,1004331,151562,48498,158330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453868 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453868 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001269s ]