SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35433 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35433 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324986,763771,395491,257771,193709,413191,321876,400497,121755,876975,325993,706033,1000147,414363,357205,357485,815122,994373,431708,345732,324790,543127,30995,788689,675764,299745,326894,237462,849878,997973,40368,696300,86209,883773,1043994,532495,747158,204000,782212,335407,367974,706711,673335,471684,142147,665420,864438,797364,1036179,787946,631490,856518,131347,407135,381666,615057,735311,683139,169859,385032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]