SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022978 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022978 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239291,1002285,902816,133111,553764,731270,581236,1006052,10779,1040857,94576,509983,474175,525756,951781,483788,654406,1034077,639887,387009,277588,573178,276682,542251,411586,927333,134854,576891,987480,389097,437726,583725,113079,171965,608013,251745,837471,665887,691033,848742,853971,203958,66114,722480,457736,612447,230540,483722,379560,212303,693128,118479,755656,47797,359694,397792,875204,669607,217189,564713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]