SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464051 LIMIT 1 [ RunTime:0.000846s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464051 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512362,254009,644823,710428,656558,720095,410451,140073,207038,725939,312083,559725,750841,209043,253672,1042058,887954,383898,627830,408518,40699,949735,480766,355843,988041,697679,581298,408293,46096,394151,844182,716378,556633,521712,735700,716256,307634,497294,773784,662919,467317,36957,854583,450494,601459,759482,68906,474970,600676,157548,281230,347494,924168,977877,963251,83233,967891,189469,694321,1007151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]