SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014992 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014992 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480971,844176,17140,970619,541943,932936,218705,978912,895783,310087,669488,942999,892453,96359,705403,539295,249006,791161,1032312,472168,1008604,556986,900193,603162,654131,707856,207967,1027956,951344,63577,278898,201166,579768,544215,259748,687703,678266,185514,147260,387936,908673,863328,923108,979202,71677,230683,839510,424691,896396,56712,279552,445519,173101,693228,294711,620960,42386,180973,602994,672402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003946s ]