SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 164678 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 164678 [ RunTime:0.002629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133714,406025,856341,577455,933124,1018978,343948,443356,191927,207168,12097,570976,1004204,587616,652234,419343,412682,175791,1018713,924931,821400,756816,586626,537097,105421,109169,1038384,846966,948896,981999,578324,904476,456694,620463,930100,501762,232321,489574,698842,882429,1034635,904195,800961,394441,365816,49768,797454,660191,237244,607789,330950,1015949,770224,463368,295001,228258,6677,79676,300510,702203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 164678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 164678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]