SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001691s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34172 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34172 [ RunTime:0.003440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336369,142307,633907,149468,39881,315263,763403,15960,1029957,652824,676630,940089,814728,134863,686245,489198,578177,284744,733369,1031681,587335,426675,310334,279453,168139,755112,656096,868930,1001275,81275,438161,823221,695237,942447,451140,23995,317791,172174,8324,503781,970481,861530,453351,1000830,404727,366388,284846,1003772,542203,303338,684889,47351,148025,854399,416047,287005,233121,824038,711010,470164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34172 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34172 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]