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` = 53695 LIMIT 1 [ RunTime:0.001157s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53695 [ RunTime:0.002867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502683,1022551,779087,901010,886356,107308,1008597,702427,449646,308241,434862,349241,495469,639670,158901,41452,227728,643037,1028954,525480,484161,119986,331902,617377,140831,598333,959676,28443,597651,909788,1000971,89181,345307,695910,964436,481398,521651,330988,219193,811884,561110,562912,962420,806815,284008,1036637,586683,658558,691959,72447,401775,470110,576301,830295,269952,534807,1013873,76116,987784,284870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53695 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53695 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]