SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497010 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497010 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656620,820327,39246,236042,343696,836593,805518,818958,784720,713515,10107,316352,693836,595894,858476,243523,47309,198137,926705,53289,901824,63504,893308,376451,883176,302705,490476,38880,265164,229057,512963,334238,865830,166250,98274,642218,179049,639929,87122,641466,904599,98633,619696,583659,902560,361300,90951,710605,6970,747742,686138,198383,380151,930268,485126,873605,171722,24588,724099,574239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]