SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467948 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467948 [ RunTime:0.001117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851810,677733,719458,658044,1035593,402919,875597,528994,500970,175100,822066,14139,389227,732652,987546,763255,408820,484243,185260,827994,937224,375573,632420,219367,671898,1011675,235348,883081,537380,523247,515807,968513,645481,884204,622762,751087,814429,21730,28271,824846,446224,24583,247632,948612,285073,518156,769795,644417,900884,397764,403614,124272,548674,366123,209822,791241,558811,848502,27627,839047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]