SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1313 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1313 [ RunTime:0.003893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152637,340053,857300,841430,767703,624976,198078,188566,451318,612141,381558,67684,479531,653107,109203,459790,409300,518399,598071,739385,119258,202864,338648,45025,78013,552922,739260,185889,533355,704353,54607,354989,252446,119,240251,473490,102296,472714,515008,443243,546548,422461,449427,59014,346035,635493,889259,653240,206652,839949,857708,482605,348620,388787,950565,822843,969457,757006,738800,1044788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002809s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001701s ]