SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447722 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447722 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (887862,463692,110137,479342,1048008,435179,1013850,667413,768568,590139,88461,55593,741989,399048,323987,717203,473643,735822,10247,621449,535275,607701,1030824,889072,747979,367718,300132,375194,167108,819507,824650,435051,445694,671175,122619,232611,844391,160804,227680,856113,508429,1000191,514034,656855,970254,952370,431779,677468,619912,531531,358628,742823,938474,434080,109451,472412,564796,4493,596305,7983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]