SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470616 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470616 [ RunTime:0.001474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114518,212515,829161,441491,524140,695368,986095,719168,27089,723480,1026229,876228,919922,91381,261501,447704,849600,851657,981253,779860,714672,114560,457612,846005,448054,342081,996717,846361,349922,1024473,155329,345279,831786,930387,338660,841388,594122,75623,586507,759249,790703,746405,726381,677844,951255,166500,426793,660688,442149,198784,346380,356702,312568,276737,162105,411412,658372,842973,883016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]