SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399681 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399681 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838743,996437,453603,133718,156227,464401,431035,720103,425667,883838,149744,69505,598828,269278,33446,579042,63054,570417,387883,408328,749477,993775,707806,170169,556072,146410,252552,667707,1036917,807694,235373,131829,716311,274447,160339,456361,104832,906421,100256,90157,536076,434313,857042,145303,403261,623289,816536,560913,562409,689203,147087,535827,616269,637768,42858,685202,299776,130104,335620,708761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]