SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244528 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244528 [ RunTime:0.002238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257399,253769,119605,392949,36851,859910,680380,328915,902968,627722,1033012,87409,331974,157106,111355,145011,455821,74447,613289,39566,290474,587697,496896,776404,1009269,304599,333679,486011,511092,665876,53878,484171,864784,259787,581903,898928,317966,699031,616750,178308,481415,662003,221313,705612,1039065,129691,7327,388108,449861,975383,824706,105881,357155,231044,831427,841181,337649,954146,182259,519575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000954s ]