SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002389 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002389 [ RunTime:0.002367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930666,599584,451216,198988,61200,1022702,795723,527296,133090,285991,107000,110287,915110,958740,459493,916886,620740,327236,777218,98416,922237,148689,902287,461795,734129,464193,565892,378063,470608,513136,823359,482450,1048789,834308,870848,17900,648234,133321,694343,770374,1032069,600674,694975,478083,724234,684000,771490,855549,359248,331388,191387,55534,970849,170454,584982,468867,434793,259176,187261,380403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]