SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 648452 LIMIT 1 [ RunTime:0.000597s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 648452 [ RunTime:0.008097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427634,255330,438589,212138,628911,664345,236731,580731,43704,1001128,862991,154216,24308,873406,556017,361849,630797,931733,1029437,884357,263694,976467,21804,651680,14078,817835,190951,38172,190019,405814,803441,774110,199962,565667,78472,1028632,234866,526669,431308,999835,610131,96006,295427,951933,178439,816919,394316,342379,380020,888596,422431,523082,480919,1014456,18750,497187,507973,555081,51392,507970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 648452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 648452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001122s ]