SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010067 LIMIT 1 [ RunTime:0.001937s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010067 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818628,160679,934449,793898,874065,610670,791777,133961,165718,565370,465939,700052,176182,560101,462699,499894,731248,969002,834399,505096,492533,921068,29637,794059,478724,1003935,144889,489978,826618,2909,397734,690503,740954,294677,395873,318256,308191,38368,683649,198237,944434,587390,498002,486681,40808,754227,576255,617490,103145,609912,385778,56037,231777,714376,871289,1011638,682363,256000,311266,779566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]