SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503642 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503642 [ RunTime:0.002481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674456,178209,968890,170389,547618,789253,286250,634838,51062,423424,430259,998032,954983,992772,660713,321028,500220,958907,612731,956416,478898,706731,708955,904424,597653,397226,597948,345349,519750,1023204,428554,186194,569898,200693,424548,863553,651011,162706,339791,503681,115642,691211,915942,14248,87810,378874,889278,753485,198454,692700,159749,444573,28204,691286,661012,84698,915482,106273,629555,91434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]