SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502881 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502881 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404759,620536,10845,489505,489665,988326,983031,880942,948778,661024,971162,726672,612784,492896,833957,972860,354104,687508,826135,589979,39249,861834,713412,587221,655075,864538,611761,970759,190336,887077,470553,341828,44054,954689,850837,686409,99008,407629,557453,609935,612812,566450,462456,780077,695296,546309,485023,21904,563310,181598,554222,679342,148886,519061,513910,838224,898935,402370,409845,806370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]