SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001547s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401338 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401338 [ RunTime:0.005788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938292,459406,795964,550695,470700,1017522,860433,105476,70114,789342,470623,771842,755812,597840,452511,634650,132741,569586,743305,381604,446000,698478,104122,781851,886762,649284,736771,553472,551628,479148,458770,472691,813517,629082,780187,951426,228089,372612,103801,463690,838393,164401,763901,405991,58559,163552,68251,390863,99257,683487,635900,573761,414950,682004,812256,843355,383234,170156,368072,558508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401338 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401338 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001363s ]