SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039866 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039866 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489679,332222,432535,962156,202819,278049,139556,1000161,147627,456251,817179,495990,590139,285816,223964,433348,23765,337489,430946,236587,922067,354133,300656,212250,582272,678926,598744,852093,768937,901031,578851,296963,528454,257991,982988,660108,389708,680852,806653,473260,728095,650169,1039385,41695,345886,358968,44173,630624,188411,538705,187818,901754,1021576,340261,317523,156877,879950,897883,383527,172112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039866 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039866 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]