SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200879 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200879 [ RunTime:0.003478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5268,708140,1048699,808767,79330,438077,38428,975511,191149,1037283,686421,1033192,1025098,292360,856490,227184,946219,300625,341378,605977,826644,401018,110399,755453,288360,782745,309031,1000401,531175,156879,1004067,182799,811082,251127,905593,462379,111926,706548,865857,310703,274445,795266,783483,679588,213539,662141,573480,190864,471233,174894,236210,20870,110963,291847,504406,170345,960019,844290,121307,405453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001076s ]