SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 224407 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 224407 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326513,882322,978818,469918,161453,707621,815720,491464,80730,989009,110261,124820,614820,496489,618846,388485,328944,709746,36013,587194,213544,56308,705757,298360,84760,394539,907794,1016041,699160,225076,737601,188004,54090,251613,872751,492869,696301,684079,511883,321680,36503,675594,164186,491134,243024,482767,256690,593772,633236,209707,165897,50906,63849,1008638,353144,127022,229087,383444,37979,831240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 224407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 224407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]