SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342929 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342929 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936333,208244,910572,479223,817360,1002537,393677,352197,772033,364631,149760,49943,614572,785938,581539,693089,53409,23700,651396,7626,924497,728048,367602,911151,95567,503029,1005843,398242,198730,848464,311510,389999,416239,900109,504534,843322,62228,206960,861000,1008013,949184,429798,960052,274253,148933,961703,180583,1040470,568969,948,520708,370569,121346,106321,156497,380951,685979,730132,699273,871458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]