SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441207 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441207 [ RunTime:0.002272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929919,996324,641447,488950,182917,105246,705011,17179,185708,288494,202705,478360,1046953,771046,757042,729222,59058,607641,60880,460869,622120,328341,154681,816049,841831,168568,367800,118603,56616,867150,269958,230872,1008711,776133,711590,540813,899381,1039160,552713,303005,604175,958291,62447,711207,298289,949855,14705,452869,5160,145848,220770,62571,370382,755719,746292,930392,438407,594326,950564,556846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000774s ]