SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022075 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022075 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132371,633548,180716,965194,771156,701927,596045,793791,687865,310749,674563,76585,1004051,979684,864737,312453,294119,241015,70304,681464,249504,709702,429880,38894,942942,662517,165649,917885,844735,267327,447541,506846,24824,244583,116824,579646,738072,960265,309708,546269,786158,288339,107535,626324,174849,279067,30050,600694,801110,964482,625873,104116,1041272,570403,308031,768618,418557,648290,537970,256376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000942s ]