SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502856 LIMIT 1 [ RunTime:0.001912s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502856 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112237,100852,312991,532721,50895,571935,1011046,833213,506373,419277,480075,139177,390253,808299,552140,696351,647893,827765,75320,842323,791871,327278,30637,510121,487789,780575,165170,684573,522020,824432,741036,419030,48711,296374,263100,110536,979535,27704,838844,939005,602656,620012,943148,402991,529733,80207,213198,660332,111165,848615,858551,447513,376066,180916,273330,495310,618272,236534,843929,551639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]