SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 389244 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 389244 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402097,84974,297848,477749,106180,204409,711912,840458,586927,859320,10323,770374,659340,405303,271031,479914,743595,1046459,558720,135438,1043531,82881,426158,783734,176372,1040498,869067,818140,366997,107541,924600,805251,443637,938188,634410,582898,650477,454541,254957,965325,4524,836687,69702,32865,14797,230992,538601,466757,846492,34466,795883,948210,942971,263217,105660,629510,870139,531250,399025,688203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 389244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 389244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]