SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412513 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412513 [ RunTime:0.008402s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907675,804329,86452,172860,614918,611740,110649,1033311,570243,242099,951894,343680,743271,385784,94248,423051,250182,908889,992309,272656,74143,7291,92460,137451,920118,979298,122227,419448,600421,401567,134141,501707,310336,855225,459729,590499,882573,877550,254763,505411,771297,912068,669760,624530,206119,403560,248776,564381,157964,262632,459532,1007934,320724,659371,539250,854236,1020852,77494,882952,125876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]