SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343438 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343438 [ RunTime:0.002340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362112,453629,467706,128858,567605,585058,964195,26453,261961,495173,508518,244308,730529,661435,532661,743585,219588,377077,737515,780332,663538,487942,102441,121306,827499,531174,618142,783754,783791,950661,312706,848561,1024433,686297,701689,947422,234558,396396,200812,256080,844495,705975,253542,721287,1032669,223577,964487,183095,885907,870318,715042,9331,351274,908848,419865,575217,908744,354964,522971,265969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]