SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 667580 LIMIT 1 [ RunTime:0.000593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 667580 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608533,312434,855092,356853,831638,127163,562866,146171,335410,976229,527137,1002185,67740,917762,1014610,311793,963883,240101,34604,374728,770150,241576,851215,599644,853851,133080,655580,194540,715234,514947,815223,742025,488968,299593,566960,632162,1015243,40664,11771,132074,672001,557098,943871,184025,568574,932312,143528,404155,396600,1018746,800013,17063,465958,552043,315000,938357,845319,34059,189480,746659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 667580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 667580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]