SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 922805 LIMIT 1 [ RunTime:0.004613s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 922805 [ RunTime:0.002071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731618,1037385,751033,437720,671006,918908,150014,306261,776241,691209,276626,1048043,210507,379631,846565,532142,403354,470577,111272,824402,162146,683412,435360,791595,445847,703583,847958,104335,1045869,249625,507503,263179,553266,153073,450028,908223,1001243,715903,177167,319349,447750,784784,477375,236986,434250,1025844,452541,72060,47198,752802,672943,747162,1035621,923050,945179,896459,210515,799171,1047338,534369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 922805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 922805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]